Pastes formats, styles, borders, and protection settings into a range or collection without changing cell contents. Not available unless a cell is selected.

Pastes formats, styles, borders, and protection settings into a range or collection without changing cell contents.

Pastes cell contents into a range or collection without changing formats, styles, borders, or protection setting. Not available unless a cell is selected.

Pastes cell contents into a range or collection without changing formats, styles, borders, or protection setting.